Rich Formatting for a Data Label Associated with a Data Point

ABSTRACT

Rich formatting may be provided for rich data labels. A rich data label may be created for at least one data point associated with a visualization. The data label may be formatted and displayed on the visualization. The rich data label may bind to a particular data point rather than adhering to conventional index-based anchor logic where a data label is bound to the index of a data point. Accordingly, in response to determining that the location of the data point has changed in the visualization, the location of the rich data label is automatically adjusted to remain attached to its original data point.

BACKGROUND

Rich formatting may be provided for data labels. Conventional datalabels—callouts that may be used to enhance understanding of a displaylike a chart by highlighting, emphasizing, and/or providing moreinformation about particular data points—suffer from a number ofdrawbacks. In some situations, data labels are rectangular, cannot bemanually resized and do not offer rich formatting controls such asjustification, margins, and columns. Furthermore, data labels do notfollow the data point they are intended to enhance if the data is sortedor filtered. Also, current data label systems are limited to a singledata point and cannot pull from a range of data. For example, if thethird data point in a series is orange and has a data label, theseproperties are stored on “Data Point #3”. If a chart event occurs thatcauses the indices of the data points to change (e.g. if the data issorted), these properties remain on “Data Point #3”, despite it notnecessarily being the data point that the user had originally intendedto format.

SUMMARY

This Summary is provided to introduce a selection of concepts in asimplified form that are further described below in the DetailedDescription. This Summary is not intended to identify key features oressential features of the claimed subject matter. Nor is this Summaryintended to be used to limit the claimed subject matter's scope.

Rich data label formatting may be provided. A rich data label may becreated for at least one data point associated with a visualization. Thedata label may be formatted and displayed on the visualization. Inresponse to determining that the change event has occurred on thevisualization, the display of the formatted label may be updatedaccording to the change event.

Both the foregoing general description and the following detaileddescription provide examples and are explanatory only. Accordingly, theforegoing general description and the following detailed descriptionshould not be considered to be restrictive. Further, features orvariations may be provided in addition to those set forth herein. Forexample, embodiments may be directed to various feature combinations andsub-combinations described in the detailed description.

BRIEF DESCRIPTION OF THE DRAWINGS

The accompanying drawings, which are incorporated in and constitute apart of this disclosure, illustrate various embodiments of the presentinvention. In the drawings:

FIG. 1 is a block diagram of an operating environment;

FIG. 2 is a flow chart of a method for providing rich data labelformatting; and

FIGS. 3A-3D are block diagrams of an example data labels;

FIG. 4 is a block diagram of a computing device.

DETAILED DESCRIPTION

The following detailed description refers to the accompanying drawings.Wherever possible, the same reference numbers are used in the drawingsand the following description to refer to the same or similar elements.While embodiments of the invention may be described, modifications,adaptations, and other implementations are possible. For example,substitutions, additions, or modifications may be made to the elementsillustrated in the drawings, and the methods described herein may bemodified by substituting, reordering, or adding stages to the disclosedmethods. Accordingly, the following detailed description does not limitthe invention.

Data labels may be used to enhance a chart by highlighting, emphasizing,and/or providing more information about particular data points in achart. Rich data labels may allow access to relevant data fields havinga correlation to the associated data point beyond those recognized bythe chart, such as series and/or category names. Additionally, rich datalabels may allow users to incorporate data fields and/or freeform textas well as customize the appearance, such as by manipulating the size,shape, layout and/or text formatting. Rich data labels may also bind toa particular data point rather than adhering to conventional index-basedanchor logic where a data label is bound to the index of a data point,as opposed to the data point itself. Thus, if the sequence of datapoints changes (e.g. if the series is sorted or filtered, or if pointsare added/removed), a rich data label may remain attached to itsoriginal data point. By binding to the data point itself, any chartlayout change may result in automatic repositioning of the rich datalabel.

FIG. 1 is a block diagram of an operating environment 100 for providingrich data label formatting comprising a user workstation 110. Userworkstation 110 may comprise a data processing application 115 and maybe operative to interact with a network application 120 via a network125. For example, user workstation 110 may be operative to connect to aspreadsheet application provided by a cloud-based server 130 that mayreceive inputs from user workstation 110 and perform the necessary dataprocessing remotely from user workstation 110. User workstation 110 maycomprise, for example, an electronic communications device such as acomputer, laptop, cellular and/or IP phone, tablet, game console and/orother device. User workstation 110 may be coupled to a capture device150, that may be operative to record a user and capture spoken words,motions and/or gestures made by the user, such as with a camera and/ormicrophone. User device 135 may be further operative to capture otherinputs from the user such as by a keyboard, touchscreen, stylus and/ormouse (not pictured). Consistent with embodiments of the invention,capture device 150 may comprise any speech and/or motion detectiondevice capable of detecting the speech and/or actions of the user. Forexample, capture device 150 may comprise a Microsoft® Kinect® motioncapture device comprising a plurality of cameras and a plurality ofmicrophones.

FIG. 2 is a flow chart setting forth the general stages involved in amethod 200 consistent with an embodiment of the invention for providingrich data label formatting. Method 200 may be implemented using acomputing device 400 as described in more detail below with respect toFIG. 4. Ways to implement the stages of method 200 will be described ingreater detail below. Method 200 may begin at starting block 205 andproceed to stage 210 where computing device 400 may create a data labelfor at least one data point associated with a visualization. Forexample, a user of data processing application 115 may select a datapoint on a graph to create a rich data label 300, as described ingreater detail below with respect to FIG. 3. The data label may comprisea reference to a data value and/or a range of data values such as may bestored in a spreadsheet cell and/or plurality of cells. Such a pluralityof cells may be contiguous but need not be.

Method 200 may then advance to stage 215 where computing device 400 mayreceive an input to the data label. For example, a user may begin typinglabel content into the label.

Method 200 may then advance to stage 220 where computing device 400 mayprovide a suggested input for the data label according to the receivedtext input. For example, where a user begins typing in the name of aseries in the data set underlying the visualization (e.g., spreadsheetcell values used to create a table, graph, chart, etc.) anautomcompletion suggestion may be displayed. Possible data fields mayalso be suggested, such as header titles that may be related to the atleast one data point for which the label was created. As such, thesuggestion may comprise a field selector control proximate to the datalabel.

Method 200 may then advance to stage 225 where computing device 400 mayapply a formatting option to the data label. For example, a formattingoption may be received from the user for the data label. Such aformatting option may comprise a data field selection, a data valueselection, a data value range selection, a label shape option, a textformatting option, and/or a text alignment option.

Method 200 may then advance to stage 230 where computing device 400 maydetermine whether the data label is one of a plurality of data labelsassociated with a range of data values. For example, a series of datavalues may be associated with a line on a graph (e.g., revenue peryear). Each data point of the line may be associated with a data labelthat may provide additional information (e.g., a percentage change valueor a comparison to a competitor's revenue in that year).

If the data label is part of a range and/or series, method 200 mayadvance to stage 235 where computing device 400 may propagate theformatting change to each of the rest of the plurality of data labels.For example, the user may apply a formatting change at stage 225, suchas changing the font of the data label's text and/or changing the shapeof the data label. In the line graph example described above, theseformatting changes may be propagated to each of the other data labelsassociated with data points in that series.

After propagating the formatting at stage 235, or if the data label wasnot determined to be part of a series at stage 230, method 200 may thenadvance to stage 240 where computing device 400 may determine whether achange event has occurred on the visualization. For example, a changeevent may comprise a data sort, a data hide, a data filter, a dataaddition, a resize of the visualization, a change in a type of thevisualization, and/or a data deletion.

If a change event has occurred, method 200 may advance to stage 245where computing device 400 may update the display of the formattedlabel. For example, the data label may comprise a reference to theunderlying data value associated with the data point on thevisualization. If the location of the data point changes on thevisualization, the data label may be able to follow that data point byrecognizing that the new location is still tied to the same underlyingdata value. The data label may then be repositioned on the visualizationrelative to the data point's new location. After updating the display ofthe data label, or if no change event was detected at stage 240, method200 may end at stage 250.

FIG. 3A is a block diagram of a rich data label 300. Data label 300 maycomprise a label content 305 designed to provide additional calloutinformation to a data point on a visualization.

FIG. 3B is a block diagram of rich data label 300 illustrating a userinterface indication 310 that rich data label 300 has been selected bythe user.

FIG. 3C is a block diagram of rich data label 300 illustrating a contenthighlighting of a data field reference 320 providing information to theuser that the highlighted text comprises data fields. For example,“Canada” and “14” are highlighted to indicate that these values are tiedto underlying data. A series of data labels may be copied across avisualization with each label referencing different underlying data. Forexample, the next data label may have “China” instead of “Canada.” Suchdata fields may also be automatically updated when the underlying datais changed.

FIG. 3D is a block diagram of rich data label 300 illustrating a datafield suggestion 330. Upon selecting and/or hovering over data fieldreference 320, data field suggestion 330 may be displayed to provideadditional information about the underlying data and related datafields, such as other data in the series and/or series and category nameinformation.

An embodiment consistent with the invention may comprise a system forproviding data label formatting. The system may comprise a memorystorage and a processing unit coupled to the memory storage. Theprocessing unit may be operative to create a label for at least one datapoint associated with a visualization, format the label, display theformatted label on the visualization, and determine whether a changeevent has occurred on the visualization. In response to determining thatthe change event has occurred on the visualization, the processing unitmay be operative to update the display of the formatted label accordingto the change event.

Another embodiment consistent with the invention may comprise a systemfor providing data label formatting. The system may comprise a memorystorage and a processing unit coupled to the memory storage. Theprocessing unit may be operative to create a data label associated withat least one data point of a visualization, display a user interfacecontrol associated with the data label, receive the selection of theuser interface control, display a plurality of formatting optionsassociated with a data label associated with the at least one datapoint, receive a formatting input associated with at least one of theplurality of formatting options, apply the formatting input to the atleast one data point, and display the formatted data label on thevisualization.

Yet another embodiment consistent with the invention may comprise asystem for providing data label formatting. The system may comprise amemory storage and a processing unit coupled to the memory storage. Theprocessing unit may be operative to create a data label for at least onedata point associated with a visualization, wherein the data labelcomprises a reference to at least one data value associated with the atleast one data point receive a text input to the data label, provide asuggested input for the data label according to the received text input,provide a field selector control proximate to the data label whilereceiving the text input, evince a formatting option for the data label,wherein the formatting option comprises at least one of the following: adata field selection, a data value selection, a data value rangeselection, a label shape option, a text formatting option, and a textalignment option, apply the formatting option to the data label, anddetermine whether the data label is one of a plurality of data labelsassociated with a range of data values. In response to determining thatthe data label is one of the plurality of data labels associated withthe range of data values, the processing unit may be operative topropagate the formatting change to each of the rest of the plurality ofdata labels. The processing unit may be further operative to determinethat a change event has occurred on the visualization and, if so, updatethe display of the formatted label according to the change eventaccording to a new location of the at least one data point.

FIG. 4 is a block diagram of a system including computing device 400.Consistent with an embodiment of the invention, the aforementionedmemory storage and processing unit may be implemented in a computingdevice, such as computing device 400 of FIG. 4. Any suitable combinationof hardware, software, or firmware may be used to implement the memorystorage and processing unit. For example, the memory storage andprocessing unit may be implemented with computing device 400 or any ofother computing devices 418, in combination with computing device 400.The aforementioned system, device, and processors are examples and othersystems, devices, and processors may comprise the aforementioned memorystorage and processing unit, consistent with embodiments of theinvention. Furthermore, computing device 400 may comprise operatingenvironment 400 as described above. Methods described in thisspecification may operate in other environments and are not limited tocomputing device 400.

With reference to FIG. 4, a system consistent with an embodiment of theinvention may include a computing device, such as computing device 400.In a basic configuration, computing device 400 may include at least oneprocessing unit 402 and a system memory 404. Depending on theconfiguration and type of computing device, system memory 404 maycomprise, but is not limited to, volatile (e.g. random access memory(RAM)), non-volatile (e.g. read-only memory (ROM)), flash memory, or anycombination. System memory 404 may include operating system 405, one ormore programming modules 406, and may include data processingapplication 115. Operating system 405, for example, may be suitable forcontrolling computing device 400's operation. Furthermore, embodimentsof the invention may be practiced in conjunction with a graphicslibrary, other operating systems, or any other application program andis not limited to any particular application or system. This basicconfiguration is illustrated in FIG. 4 by those components within adashed line 408.

Computing device 400 may have additional features or functionality. Forexample, computing device 400 may also include additional data storagedevices (removable and/or non-removable) such as, for example, magneticdisks, optical disks, or tape. Such additional storage is illustrated inFIG. 4 by a removable storage 409 and a non-removable storage 410.Computing device 400 may also contain a communication connection 416that may allow device 400 to communicate with other computing devices418, such as over a network in a distributed computing environment, forexample, an intranet or the Internet. Communication connection 416 isone example of communication media.

The term computer readable media as used herein may include computerstorage media. Computer storage media may include volatile andnonvolatile, removable and non-removable media implemented in any methodor technology for storage of information, such as computer readableinstructions, data structures, program modules, or other data. Systemmemory 404, removable storage 409, and non-removable storage 410 are allcomputer storage media examples (i.e., memory storage.) Computer storagemedia may include, but is not limited to, RAM, ROM, electricallyerasable read-only memory (EEPROM), flash memory or other memorytechnology, CD-ROM, digital versatile disks (DVD) or other opticalstorage, magnetic cassettes, magnetic tape, magnetic disk storage orother magnetic storage devices, or any other medium which can be used tostore information and which can be accessed by computing device 400. Anysuch computer storage media may be part of device 400. Computing device400 may also have input device(s) 412 such as a keyboard, a mouse, apen, a sound input device, a touch input device, etc. Output device(s)414 such as a display, speakers, a printer, etc. may also be included.The aforementioned devices are examples and others may be used.

The term computer readable media as used herein may also includecommunication media. Communication media may be embodied by computerreadable instructions, data structures, program modules, or other datain a modulated data signal, such as a carrier wave or other transportmechanism, and includes any information delivery media. The term“modulated data signal” may describe a signal that has one or morecharacteristics set or changed in such a manner as to encode informationin the signal. By way of example, and not limitation, communicationmedia may include wired media such as a wired network or direct-wiredconnection, and wireless media such as acoustic, radio frequency (RF),infrared, and other wireless media.

As stated above, a number of program modules and data files may bestored in system memory 404, including operating system 405. Whileexecuting on processing unit 402, programming modules 406 (e.g., dataprocessing application 115) may perform processes and/or methods asdescribed above. The aforementioned process is an example, andprocessing unit 402 may perform other processes. Other programmingmodules that may be used in accordance with embodiments of the presentinvention may include electronic mail and contacts applications, wordprocessing applications, spreadsheet applications, databaseapplications, slide presentation applications, drawing or computer-aidedapplication programs, etc.

Generally, consistent with embodiments of the invention, program modulesmay include routines, programs, components, data structures, and othertypes of structures that may perform particular tasks or that mayimplement particular abstract data types. Moreover, embodiments of theinvention may be practiced with other computer system configurations,including hand-held devices, multiprocessor systems,microprocessor-based or programmable consumer electronics,minicomputers, mainframe computers, and the like. Embodiments of theinvention may also be practiced in distributed computing environmentswhere tasks are performed by remote processing devices that are linkedthrough a communications network. In a distributed computingenvironment, program modules may be located in both local and remotememory storage devices.

Furthermore, embodiments of the invention may be practiced in anelectrical circuit comprising discrete electronic elements, packaged orintegrated electronic chips containing logic gates, a circuit utilizinga microprocessor, or on a single chip containing electronic elements ormicroprocessors. Embodiments of the invention may also be practicedusing other technologies capable of performing logical operations suchas, for example, AND, OR, and NOT, including but not limited tomechanical, optical, fluidic, and quantum technologies. In addition,embodiments of the invention may be practiced within a general purposecomputer or in any other circuits or systems.

Embodiments of the invention, for example, may be implemented as acomputer process (method), a computing system, or as an article ofmanufacture, such as a computer program product or computer readablemedia. The computer program product may be a computer storage mediareadable by a computer system and encoding a computer program ofinstructions for executing a computer process. The computer programproduct may also be a propagated signal on a carrier readable by acomputing system and encoding a computer program of instructions forexecuting a computer process. Accordingly, the present invention may beembodied in hardware and/or in software (including firmware, residentsoftware, micro-code, etc.). In other words, embodiments of the presentinvention may take the form of a computer program product on acomputer-usable or computer-readable storage medium havingcomputer-usable or computer-readable program code embodied in the mediumfor use by or in connection with an instruction execution system. Acomputer-usable or computer-readable medium may be any medium that cancontain, store, communicate, propagate, or transport the program for useby or in connection with the instruction execution system, apparatus, ordevice.

The computer-usable or computer-readable medium may be, for example butnot limited to, an electronic, magnetic, optical, electromagnetic,infrared, or semiconductor system, apparatus, device, or propagationmedium. More specific computer-readable medium examples (anon-exhaustive list), the computer-readable medium may include thefollowing: an electrical connection having one or more wires, a portablecomputer diskette, a random access memory (RAM), a read-only memory(ROM), an erasable programmable read-only memory (EPROM or Flashmemory), an optical fiber, and a portable compact disc read-only memory(CD-ROM). Note that the computer-usable or computer-readable mediumcould even be paper or another suitable medium upon which the program isprinted, as the program can be electronically captured, via, forinstance, optical scanning of the paper or other medium, then compiled,interpreted, or otherwise processed in a suitable manner, if necessary,and then stored in a computer memory.

Embodiments of the invention may be practiced via a system-on-a-chip(SOC) where each and/or many of the components illustrated above may beintegrated onto a single integrated circuit. Such an SOC device mayinclude one or more processing units, graphics units, communicationsunits, system virtualization units and various applicationfunctionalities, all of which may be integrated (or “burned”) onto thechip substrate as a single integrated circuit. When operating via anSOC, the functionality, described herein, with respect to trainingand/or interacting with any component of operating environment 100 mayoperate via application-specific logic integrated with other componentsof the computing device/system on the single integrated circuit (chip).

Embodiments of the present invention, for example, are described abovewith reference to block diagrams and/or operational illustrations ofmethods, systems, and computer program products according to embodimentsof the invention. The functions/acts noted in the blocks may occur outof the order as shown in any flowchart. For example, two blocks shown insuccession may in fact be executed substantially concurrently or theblocks may sometimes be executed in the reverse order, depending uponthe functionality/acts involved.

While certain embodiments of the invention have been described, otherembodiments may exist. Furthermore, although embodiments of the presentinvention have been described as being associated with data stored inmemory and other storage mediums, data can also be stored on or readfrom other types of computer-readable media, such as secondary storagedevices, like hard disks, floppy disks, or a CD-ROM, a carrier wave fromthe Internet, or other forms of RAM or ROM. Further, the disclosedmethods' stages may be modified in any manner, including by reorderingstages and/or inserting or deleting stages, without departing from theinvention.

All rights including copyrights in the code included herein are vestedin and the property of the Applicants. The Applicants retain and reserveall rights in the code included herein, and grant permission toreproduce the material only in connection with reproduction of thegranted patent and for no other purpose.

While certain embodiments of the invention have been described, otherembodiments may exist. While the specification includes examples, theinvention's scope is indicated by the following claims. Furthermore,while the specification has been described in language specific tostructural features and/or methodological acts, the claims are notlimited to the features or acts described above. Rather, the specificfeatures and acts described above are disclosed as example forembodiments of the invention.

1.-20. (canceled)
 21. A method for providing data label formatting, themethod comprising: creating a data label for a data point associatedwith a visualization, wherein the data label comprises a reference to adata value associated with the data point; receiving a text input to thedata label; receiving a formatting option for formatting the data label;applying the formatting option to format the data label; determiningthat a change event has occurred on the visualization; and in responseto determining that the change event has occurred on the visualization,updating the display of the formatted data label by automaticallyadjusting a location of the formatted data label according to a newlocation of the data point in response to the change event.
 22. Themethod of claim 21, wherein the visualization comprises at least one ofthe following: a chart, a table, and a graph.
 23. The method of claim21, wherein the formatting option is a data field selection, a datavalue selection, a data value range selection, a label shape option, atext formatting option, or a text alignment option.
 24. The method ofclaim 21, wherein the data label comprises a text string and a datafield, wherein the data field is populated according to a property ofthe data point.
 25. The method of claim 24, wherein the property of theassociated data point comprises at least one of the following: a seriesname, a category name, a value, a percentage, and a size.
 26. The methodof claim 24, further comprising providing a user interface indicationthat the data field is present in the formatted data label.
 27. Themethod of claim 21, further comprising: determining that the data labelis one of a plurality of data labels associated with a range of datavalues; and propagating the formatting change to each of the rest of theplurality of data labels.
 28. The method of claim 21, wherein the datalabel comprises a rich data label.
 29. The method of claim 21, whereinthe data label is associated with a cell reference of the data points.30. The method of claim 21, wherein the data label comprises one of aseries of data labels associated with a plurality of data points.
 31. Asystem for providing data label formatting, the system comprising: amemory storage device; and a hardware processing unit coupled to thememory storage device, wherein the hardware processing unit is operableto: create a data label for a data point, wherein the data point is partof a visualization, wherein the data label comprises a reference to adata value associated with the data point, the data label comprising arich data label; receive a format change to the data label; apply theformat change to the data label; determine whether a change event hasoccurred on the visualization; and in response to determining that thechange event has occurred on the visualization, update the display ofthe formatted data label by automatically adjusting a location of theformatted data label according to a new location of the data point inresponse to the change event.
 32. The system of claim 31, furthercomprising: determining that the data label is one of a plurality ofdata labels associated with a range of data values; and propagating theformat change to each of the rest of the plurality of data labels. 33.The system of claim 31, wherein the data label is changed via textinput.
 34. The system of claim 31, wherein the hardware processing unitis further operative to create a plurality of data labels eachassociated with the data point.
 35. The system of claim 34, whereinmultiple data labels may be changed based on a common formatting option.36. The system of claim 31, wherein the formatting option is a datafield selection, a data value selection, a data value range selection, alabel shape option, a text formatting option, or a text alignmentoption.
 37. A memory storage device storing a set of instructions thatwhen executed by a computing device, causes the computing device toperform a method for providing data label formatting, the methodcomprising: creating a data label for at least one data point associatedwith a visualization, wherein the data label comprises a reference to atleast one data value associated with the at least one data point, thedata label comprising a rich data label; receiving a edit to the datalabel; applying the edit to the data label; determining whether a changeevent has occurred on the visualization, wherein the change eventcomprises at least one of the following: a data sort, a data hide, adata filter, a data addition, a resize of the visualization, a change ina type of the visualization, and a data deletion; and in response todetermining that the change event has occurred on the visualization,updating the display of the formatted label by automatically adjustingthe location of the edit data label according to a new location of theat least one data point in response to the change event.
 38. The memorystorage device of claim 37, wherein the edit is a data field selection,a data value selection, a data value range selection, a label shapeoption, a text formatting option, or a text alignment option.
 39. Thememory device of claim 37, further comprising: determining that the datalabel is one of a plurality of data labels associated with a range ofdata values; and propagating the formatting change to each of the restof the plurality of data labels.
 40. The memory device of claim 37,wherein the data label is edit via text input.